﻿CREATE TABLE [dbo].[UserPartRecord] (
    [Id]                  INT            IDENTITY (1, 1) NOT NULL,
    [UserName]            NVARCHAR (255) NOT NULL,
    [Email]               NVARCHAR (255) NOT NULL,
    [NormalizedUserName]  NVARCHAR (255) NOT NULL,
    [Password]            NVARCHAR (255) NOT NULL,
    [PasswordFormat]      NVARCHAR (255) NOT NULL,
    [HashAlgorithm]       NVARCHAR (255) NOT NULL,
    [PasswordSalt]        NVARCHAR (255) NOT NULL,
    [RegistrationStatus]  INT            NOT NULL,
    [EmailStatus]         INT            NOT NULL,
    [EmailChallengeToken] NVARCHAR (255) NULL,
    [Status] INT NOT NULL DEFAULT 0, 
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

